Tabela PerfDrugChange

Definicja tabeli PerfDrugChange

Name

PerfDrugChange

Code

PerfDrugChange

Comment

tabela opisuje zmiany w zleceniu leków


Lista kolumn tabeli PerfDrugChange

Name

Code

PerfDrugChangeID

PerfDrugChangeID

PerfDrugID

PerfDrugID

PerfDrugChangeTypeID

PerfDrugChangeTypeID

DateValue

DateValue

PersonID

PersonID

Comments

Comments


Kolumna PerfDrugChangeID tabeli PerfDrugChange

Definicja kolumny PerfDrugChangeID tabeli PerfDrugChange

Name

PerfDrugChangeID

Code

PerfDrugChangeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PerfDrugID tabeli PerfDrugChange

Definicja kolumny PerfDrugID tabeli PerfDrugChange

Name

PerfDrugID

Code

PerfDrugID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PerfDrugChangeTypeID tabeli PerfDrugChange

Definicja kolumny PerfDrugChangeTypeID tabeli PerfDrugChange

Name

PerfDrugChangeTypeID

Code

PerfDrugChangeTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DateValue tabeli PerfDrugChange

Definicja kolumny DateValue tabeli PerfDrugChange

Name

DateValue

Code

DateValue

Data Type

DATE

Mandatory

No

Comment

 


Kolumna PersonID tabeli PerfDrugChange

Definicja kolumny PersonID tabeli PerfDrugChange

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Comments tabeli PerfDrugChange

Definicja kolumny Comments tabeli PerfDrugChange

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Lista kluczy tabeli PerfDrugChange

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli PerfDrugChange

Definicja klucza Identifier_1 tabeli PerfDrugChange

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment